One moment please...
 
 
Exact Synergy Enterprise   
 

How-to: Using SQL script for automated creation of background jobs for Exact Synergy Enterprise

Introduction

This document provides the steps on how to use the SQL script to perform multiple background jobs concurrently. The SQL script has been attached and can be downloaded in this document.

Description

With every installation of Exact Synergy Enterprise, there is a number of background jobs available that perform specific tasks on the database. These background jobs are performed with parameters and can be scheduled via Microsoft SQL Server Agent or Windows Task Scheduler. The background jobs are scheduled every 30 minutes.

The SQL script contains several variables that need to be inserted before the SQL script is executed. The variables are: 

  • Server
  • DBCONFIG
  • BaseURL
  • Location
  • TempDrive
  • Exchangesrv
  • Login 

Note that the created background jobs are disabled by default and can be enabled in Job Activity Monitor.

How do I use the SQL script? 

  1. Download the SQL script that has been attached in this document.
  2. Open the SQL script in SQL Server Management Studio.
  3. Execute the SQL script on the master database. 

Related document 

 

     
 Main Category: Support Product Know How  Document Type: Online help main
 Category: On-line help files  Security  level: All - 0
 Sub category: General  Document ID: 16.316.414
 Assortment:  Date: 14-01-2019
 Release:  Attachment:
 Disclaimer

Attachments
Synergy_Enterprise_backgroundjobs (v20181204).sql 16.5 KB View Download